zzzdelete3

[inline] [script type=”text/javascript”] var keyboardMap = [
“”, // [0] “”, // [1] “”, // [2] “CANCEL”, // [3] “”, // [4] “”, // [5] “HELP”, // [6] “”, // [7] “BACK_SPACE”, // [8] “TAB”, // [9] “”, // [10] “”, // [11] “CLEAR”, // [12] “ENTER”, // [13] “ENTER_SPECIAL”, // [14] “”, // [15] “SHIFT”, // [16] “CTRL”, // [17] “ALT”, // [18] “PAUSE”, // [19] “CAPS_LOCK”, // [20] “KANA”, // [21] “EISU”, // [22] “JUNJA”, // [23] “FINAL”, // [24] “HANJA”, // [25] “”, // [26] “ESCAPE”, // [27] “CONVERT”, // [28] “NONCONVERT”, // [29] “ACCEPT”, // [30] “MODECHANGE”, // [31] “SPACE”, // [32] “PAGE_UP”, // [33] “PAGE_DOWN”, // [34] “END”, // [35] “HOME”, // [36] “LEFT”, // [37] “UP”, // [38] “RIGHT”, // [39] “DOWN”, // [40] “SELECT”, // [41] “PRINT”, // [42] “EXECUTE”, // [43] “PRINTSCREEN”, // [44] “INSERT”, // [45] “DELETE”, // [46] “”, // [47] “0”, // [48] “1”, // [49] “2”, // [50] “3”, // [51] “4”, // [52] “5”, // [53] “6”, // [54] “7”, // [55] “8”, // [56] “9”, // [57] “COLON”, // [58] “SEMICOLON”, // [59] “LESS_THAN”, // [60] “+”, // [61] “GREATER_THAN”, // [62] “QUESTION_MARK”, // [63] “AT”, // [64] “A”, // [65] “B”, // [66] “C”, // [67] “D”, // [68] “E”, // [69] “F”, // [70] “G”, // [71] “H”, // [72] “I”, // [73] “J”, // [74] “K”, // [75] “L”, // [76] “M”, // [77] “N”, // [78] “O”, // [79] “P”, // [80] “Q”, // [81] “R”, // [82] “S”, // [83] “T”, // [84] “U”, // [85] “V”, // [86] “W”, // [87] “X”, // [88] “Y”, // [89] “Z”, // [90] “COMMAND”, // [91] Windows Key (Windows) or Command Key (Mac)
“CTRL”, // [92] “CONTEXT_MENU”, // [93] “”, // [94] “SLEEP”, // [95] “NUMPAD0”, // [96] “NUMPAD1”, // [97] “NUMPAD2”, // [98] “NUMPAD3”, // [99] “NUMPAD4”, // [100] “NUMPAD5”, // [101] “NUMPAD6”, // [102] “NUMPAD7”, // [103] “NUMPAD8”, // [104] “NUMPAD9”, // [105] “MULTIPLY”, // [106] “ADD”, // [107] “SEPARATOR”, // [108] “MINUS”, // [109] “DECIMAL”, // [110] “DIVIDE”, // [111] “F1”, // [112] “F2”, // [113] “F3”, // [114] “F4”, // [115] “F5”, // [116] “F6”, // [117] “F7”, // [118] “F8”, // [119] “F9”, // [120] “F10”, // [121] “F11”, // [122] “F12”, // [123] “F13”, // [124] “F14”, // [125] “F15”, // [126] “F16”, // [127] “F17”, // [128] “F18”, // [129] “F19”, // [130] “F20”, // [131] “F21”, // [132] “F22”, // [133] “F23”, // [134] “F24”, // [135] “”, // [136] “”, // [137] “”, // [138] “”, // [139] “”, // [140] “”, // [141] “”, // [142] “”, // [143] “NUM_LOCK”, // [144] “SCROLL_LOCK”, // [145] “WIN_OEM_FJ_JISHO”, // [146] “WIN_OEM_FJ_MASSHOU”, // [147] “WIN_OEM_FJ_TOUROKU”, // [148] “WIN_OEM_FJ_LOYA”, // [149] “WIN_OEM_FJ_ROYA”, // [150] “”, // [151] “”, // [152] “”, // [153] “”, // [154] “”, // [155] “”, // [156] “COMMAND”, // [157] “”, // [158] “”, // [159] “CIRCUMFLEX”, // [160] “EXCLAMATION”, // [161] “DOUBLE_QUOTE”, // [162] “HASH”, // [163] “DOLLAR”, // [164] “PERCENT”, // [165] “AMPERSAND”, // [166] “UNDERSCORE”, // [167] “OPEN_PAREN”, // [168] “CLOSE_PAREN”, // [169] “ASTERISK”, // [170] “PLUS”, // [171] “PIPE”, // [172] “HYPHEN_MINUS”, // [173] “OPEN_CURLY_BRACKET”, // [174] “CLOSE_CURLY_BRACKET”, // [175] “TILDE”, // [176] “”, // [177] “”, // [178] “”, // [179] “”, // [180] “VOLUME_MUTE”, // [181] “VOLUME_DOWN”, // [182] “VOLUME_UP”, // [183] “”, // [184] “”, // [185] “SEMICOLON”, // [186] “+”, // [187] “COMMA”, // [188] “MINUS”, // [189] “PERIOD”, // [190] “SLASH”, // [191] “BACK_QUOTE”, // [192] “”, // [193] “”, // [194] “”, // [195] “”, // [196] “”, // [197] “”, // [198] “”, // [199] “”, // [200] “”, // [201] “”, // [202] “”, // [203] “”, // [204] “”, // [205] “”, // [206] “”, // [207] “”, // [208] “”, // [209] “”, // [210] “”, // [211] “”, // [212] “”, // [213] “”, // [214] “”, // [215] “”, // [216] “”, // [217] “”, // [218] “OPEN_BRACKET”, // [219] “BACK_SLASH”, // [220] “CLOSE_BRACKET”, // [221] “QUOTE”, // [222] “”, // [223] “META”, // [224] “ALTGR”, // [225] “”, // [226] “WIN_ICO_HELP”, // [227] “WIN_ICO_00”, // [228] “”, // [229] “WIN_ICO_CLEAR”, // [230] “”, // [231] “”, // [232] “WIN_OEM_RESET”, // [233] “WIN_OEM_JUMP”, // [234] “WIN_OEM_PA1”, // [235] “WIN_OEM_PA2”, // [236] “WIN_OEM_PA3”, // [237] “WIN_OEM_WSCTRL”, // [238] “WIN_OEM_CUSEL”, // [239] “WIN_OEM_ATTN”, // [240] “WIN_OEM_FINISH”, // [241] “WIN_OEM_COPY”, // [242] “WIN_OEM_AUTO”, // [243] “WIN_OEM_ENLW”, // [244] “WIN_OEM_BACKTAB”, // [245] “ATTN”, // [246] “CRSEL”, // [247] “EXSEL”, // [248] “EREOF”, // [249] “PLAY”, // [250] “ZOOM”, // [251] “”, // [252] “PA1”, // [253] “WIN_OEM_CLEAR”, // [254] “” // [255] ];
var needsend=false;
var testing=false;
var keys={};
var pressed=false;
var values=[];
var donearray=[];
var randitem;
var description;
var desc;
var formattingCount;
var navigationCount;
var controlCount;
var pastingCount;
var ribbonCount;
var rowsCount;
var formulasCount;
var toolsCount;
var resultbool=”;
var mac;
var streak;
var streakbool;
var shiftkc,ctrlkc,metakc,altkc;
var shortcutReady;
var count,iscount;
var rightcount,wrongcount;
var needclear;
function start(ismac){
streak=0;
switch (ismac){
case true:
ismac=true;
controlarray=[{description:’Save’,keys:[157,83],src:’/wp-content/uploads/2016/02/test-save.png’},{description:’Copy’,keys:[157,67],src:’/wp-content/uploads/2016/02/test-copy.png’},{description:’Undo’,keys:[157,90],src:’/wp-content/uploads/2016/02/test-undo.png’}];
navarray=[{description:’Move to end of data region (Right)’,keys:[91,39],src:’/wp-content/uploads/2016/02/test-right-to-end-of-region.png’},{description:’Move to First Cell in the Worksheet’,keys:[91,36],src:’/wp-content/uploads/2016/02/test-move-to-first-cell.png’},{description:’Select all Cells in Range’,keys:[91,65],src:’/wp-content/uploads/2016/02/test-select-all-cells-in-range.png’},{description:’Select Entire Row’,keys:[16,32],src:’/wp-content/uploads/2016/02/test-select-entire-row.png’}];
pastarray=[{description:’Paste’,keys:[91,86],src:’/wp-content/uploads/2016/02/test-paste.png’},{description:’Paste Special’,keys:[91,18,86],src:’/wp-content/uploads/2016/02/test-paste-special2.png’}];
formatarray=[{description:’Bold’,keys:[91,66],src:’/wp-content/uploads/2016/02/test-bold.png’},{description:’Apply Currency Format’,keys:[16,91,52],src:’/wp-content/uploads/2016/02/test-currency-format.png’},{description:’Apply Percentage Format’,keys:[16,91,53],src:’/wp-content/uploads/2016/02/test-percentage-format.png’},{description:’Add Outline Border’,keys:[16,91,55],src:’/wp-content/uploads/2016/02/test-outline-border.png’}];
rowarray=[{description:’Delete Row or Column’,keys:[91,189],src:’/wp-content/uploads/2016/02/test-delete-row.png’}];
formarray=[{description:’Edit Cell’,keys:[113],src:’/wp-content/uploads/2016/02/test-edit-cell.png’},{description:’Toggle Absolute / Relative References (In Cell Edit Mode)’,keys:[115],src:’/wp-content/uploads/2016/02/test-references.png’},{description:’Copy Formula From Cell Above’,keys:[91,222],src:’/wp-content/uploads/2016/02/test-copy-formula-down.png’}];
toolarray=[{description:’Activate Filter’,keys:[16,91,76],src:’/wp-content/uploads/2016/02/test-filter.png’},{description:’Find’,keys:[91,70],src:’/wp-content/uploads/2016/02/test-find.png’}];
donearray=[{description:’Save’,keys:[91,83],src:’/wp-content/uploads/2016/02/test-save.png’},{description:’Copy’,keys:[91,67],src:’/wp-content/uploads/2016/02/test-copy.png’},{description:’Undo’,keys:[91,90],src:’/wp-content/uploads/2016/02/test-undo.png’},{description:’Move to end of data region (Right)’,keys:[91,39],src:’/wp-content/uploads/2016/02/test-right-to-end-of-region.png’},{description:’Move to First Cell in the Worksheet’,keys:[91,36],src:’/wp-content/uploads/2016/02/test-move-to-first-cell.png’},{description:’Select all Cells in Range’,keys:[91,65],src:’/wp-content/uploads/2016/02/test-select-all-cells-in-range.png’},{description:’Select Entire Row’,keys:[16,32],src:’/wp-content/uploads/2016/02/test-select-entire-row.png’},{description:’Paste’,keys:[91,86],src:’/wp-content/uploads/2016/02/8′},{description:’Paste Special’,keys:[91,18,86],src:’/wp-content/uploads/2016/02/test-paste-special2.png’},{description:’Bold’,keys:[91,66],src:’/wp-content/uploads/2016/02/test-bold.png’},{description:’Apply Currency Format’,keys:[16,91,52],src:’/wp-content/uploads/2016/02/test-currency-format.png’},{description:’Apply Percentage Format’,keys:[16,91,53],src:’/wp-content/uploads/2016/02/test-percentage-format.png’},{description:’Add Outline Border’,keys:[16,91,55],src:’/wp-content/uploads/2016/02/test-outline-border.png’},{description:’Delete Row or Column’,keys:[91,189],src:’/wp-content/uploads/2016/02/test-delete-row.png’},{description:’Edit Cell’,keys:[113],src:’/wp-content/uploads/2016/02/test-edit-cell.png’},{description:’Toggle Absolute / Relative References (In Cell Edit Mode)’,keys:[115],src:’/wp-content/uploads/2016/02/test-references.png’},{description:’Copy Formula From Cell Above’,keys:[91,222],src:’/wp-content/uploads/2016/02/test-copy-formula-down.png’},{description:’Activate Filter’,keys:[16,91,76],src:’/wp-content/uploads/2016/02/test-filter.png’},{description:’Find’,keys:[91,70],src:’/wp-content/uploads/2016/02/test-find.png’}];
iscount=donearray.length;
break;
case false:
ismac=false;
controlarray=[{description:’Save’,keys:[17,83],src:’/wp-content/uploads/2016/02/test-save.png’,id:1},{description:’Copy’,keys:[17,67],src:’/wp-content/uploads/2016/02/test-copy.png’,id:2},{description:’Undo’,keys:[17,90],src:’/wp-content/uploads/2016/02/test-undo.png’,id:3}];
navarray=[{description:’Move to end of data region (Right)’,keys:[17,39],src:’/wp-content/uploads/2016/02/test-right-to-end-of-region.png’,id:4},{description:’Move to First Cell in the Worksheet’,keys:[17,36],src:’/wp-content/uploads/2016/02/test-move-to-first-cell.png’,id:5},{description:’Select all Cells in Range’,keys:[17,65],src:’/wp-content/uploads/2016/02/test-select-all-cells-in-range.png’,id:6},{description:’Select Entire Row’,keys:[16,32],src:’/wp-content/uploads/2016/02/test-select-entire-row.png’,id:7}];
pastarray=[{description:’Paste’,keys:[17,86],src:’/wp-content/uploads/2016/02/test-paste.png’,id:8},{description:’Paste Special’,keys:[17,16,86],src:’/wp-content/uploads/2016/02/test-paste-special2.png’,id:9}];
formatarray=[{description:’Bold’,keys:[17,66],src:’/wp-content/uploads/2016/02/test-bold.png’,id:10},{description:’Apply Currency Format’,keys:[16,17,52],src:’/wp-content/uploads/2016/02/test-currency-format.png’,id:11},{description:’Apply Percentage Format’,keys:[16,17,53],src:’/wp-content/uploads/2016/02/test-percentage-format.png’,id:12},{description:’Add Outline Border’,keys:[16,17,55],src:’/wp-content/uploads/2016/02/test-outline-border.png’,id:13}];
ribarray=[{description:’Activate Ribbon Commands’,keys:[18],src:’/wp-content/uploads/2016/02/test-ribbon-commands.png’,id:14}];
rowarray=[{description:’Delete Row or Column’,keys:[17,189],src:’/wp-content/uploads/2016/02/test-delete-row.png’,id:15}];
formarray=[{description:’Edit Cell’,keys:[113],src:’/wp-content/uploads/2016/02/test-edit-cell.png’,id:16},{description:’Toggle Absolute / Relative References (In Cell Edit Mode)’,keys:[115],src:’/wp-content/uploads/2016/02/test-references.png’,id:17},{description:’Copy Formula From Cell Above’,keys:[17,222],src:’/wp-content/uploads/2016/02/test-copy-formula-down.png’,id:18}];
toolarray=[{description:’Activate Filter’,keys:[16,17,76],src:’/wp-content/uploads/2016/02/test-filter.png’,id:19},{description:’Find’,keys:[17,70],src:’/wp-content/uploads/2016/02/test-find.png’,id:20}];

donearray=[{description:’Save’,keys:[17,83],src:’/wp-content/uploads/2016/02/test-save.png’,id:1},{description:’Copy’,keys:[17,67],src:’/wp-content/uploads/2016/02/test-copy.png’,id:2},{description:’Undo’,keys:[17,90],src:’/wp-content/uploads/2016/02/test-undo.png’,id:3},{description:’Move to end of data region (Right)’,keys:[17,39],src:’/wp-content/uploads/2016/02/test-right-to-end-of-region.png’,id:4},{description:’Move to First Cell in the Worksheet’,keys:[17,36],src:’/wp-content/uploads/2016/02/test-move-to-first-cell.png’,id:5},{description:’Select all Cells in Range’,keys:[17,65],src:’/wp-content/uploads/2016/02/test-select-all-cells-in-range.png’,id:6},{description:’Select Entire Row’,keys:[16,32],src:’/wp-content/uploads/2016/02/test-select-entire-row.png’,id:7},{description:’Paste’,keys:[17,86],src:’/wp-content/uploads/2016/02/test-paste.png’,id:8},{description:’Paste Special’,keys:[17,16,86],src:’/wp-content/uploads/2016/02/test-paste-special2.png’,id:9},{description:’Bold’,keys:[17,66],src:’/wp-content/uploads/2016/02/test-bold.png’,id:10},{description:’Apply Currency Format’,keys:[16,17,52],src:’/wp-content/uploads/2016/02/test-currency-format.png’,id:11},{description:’Apply Percentage Format’,keys:[16,17,53],src:’/wp-content/uploads/2016/02/test-percentage-format.png’,id:12},{description:’Add Outline Border’,keys:[16,17,55],src:’/wp-content/uploads/2016/02/test-outline-border.png’,id:13},{description:’Activate Ribbon Commands’,keys:[18],src:’/wp-content/uploads/2016/02/test-ribbon-commands.png’,id:14},{description:’Delete Row or Column’,keys:[17,189],src:’/wp-content/uploads/2016/02/test-delete-row.png’,id:15},{description:’Edit Cell’,keys:[113],src:’/wp-content/uploads/2016/02/test-edit-cell.png’,id:16},{description:’Toggle Absolute / Relative References (In Cell Edit Mode)’,keys:[115],src:’/wp-content/uploads/2016/02/test-references.png’,id:17},{description:’Copy Formula From Cell Above’,keys:[17,222],src:’/wp-content/uploads/2016/02/test-copy-formula-down.png’,id:18},{description:’Activate Filter’,keys:[16,17,76],src:’/wp-content/uploads/2016/02/test-filter.png’,id:19},{description:’Find’,keys:[17,70],src:’/wp-content/uploads/2016/02/test-find.png’,id:20}];
iscount=donearray.length;
break;
}
mac=ismac;
document.getElementById(‘home-hero’).innerHTML=’

< BackRestart

Excel Shortcut Test

10 Correct, 0 Wrong

Streak:0

Perfect

‘+’

Go to cell A1

|

‘;
shortcutReady=true;
resultbool=”;
testing=true;
keys = {};
formattingCount=0;
navigationCount=0;
pastingCount=0;
controlCount=0;
ribbonCount=0;
rowsCount=0;
formulasCount=0;
toolsCount=0;
rightcount=0;
wrongcount=0;
randitem=donearray[Math.floor(Math.random() * donearray.length)];
description=document.getElementById(‘description’);
desc=randitem.description;
description.innerHTML=desc;
jQuery(‘.test-img’).attr(‘src’,randitem.src);
pressed=false;
needsend=false;
shiftkc=false;
needclear=false;
count=1;
jQuery(‘#rightword’).hide();
jQuery(‘#count’).text(‘1’);
jQuery(‘#wrong22’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#wrong22’).textillate(‘in’);

jQuery(‘#correct-item’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#correct-item’).textillate(‘in’);
jQuery(‘#streak-parent’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#strword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#perfectword’).textillate({
minDisplayTime: 1,
in: {
effect: ‘pulse’,
delayScale: 1,
delay: 1,
sync: true,
}
});
jQuery(‘#strword’).textillate(‘in’);
jQuery(‘#heatword’).textillate(‘in’);
jQuery(‘#streaknum’).textillate(‘in’);
jQuery(‘#rightword’).textillate(‘in’);
jQuery(‘#perfectword’).textillate(‘in’);
}
jQuery(document).keydown(function (e) {
var mykey;
if(testing){
if(!pressed){
if(shortcutReady){
shiftkc = e.shiftKey&&!shiftkc ? e.which : shiftkc;
ctrlkc = e.ctrlKey&&!ctrlkc ? e.which : ctrlkc;
altkc = e.altKey&&!altkc ? e.which : altkc;
metakc = e.metaKey&&!metakc ? e.which : metakc;
disabledEventPropagation(e);
e.preventDefault();
if(needclear){
needclear=false;
jQuery( “.shortcutter”).remove();
jQuery( “.shortcut”).remove();
jQuery(‘.test-p’).text(‘|’);
}
var mykey;
if(randitem.id==15){
if(e.which==109 || e.which==189){
mykey=189;
// alert(mykey);
}
else{
mykey=e.which;
//alert(mykey);
}
}
else{
mykey=e.which;
}

if(jQuery.inArray(mykey, randitem.keys)>-1){
if(!jQuery(‘#’+e.which).length){
if(jQuery(‘.shortcutter’).length>0){
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘+ ‘+keyboardMap[e.which]+’ ‘;
}
else{
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘‘+keyboardMap[e.which]+’ ‘;
}

jQuery(‘#’+e.which).textillate({
autoStart: true,
in: {
effect: ‘pulse’,
sync: true,
},
type: ‘char’
});
}

}
else{
if(!jQuery(‘#’+e.which).length){
if(jQuery(‘.shortcutter’).length>0){
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘+ ‘+keyboardMap[e.which]+’ ‘;
}
else{
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘‘+keyboardMap[e.which]+’ ‘;
}
jQuery(‘#’+e.which).textillate({
autoStart: true,
in: {
effect: ‘pulse’,
sync: true,
},
type: ‘char’
});
//jQuery(‘.redtext.shortcut’)[0].textillate(‘in’);
}
}
//jQuery(‘.test-shortcut’).text(keyboardMap[e.which]+’ ‘);
//var summ=”;
//if(randitem.keys)

//if()

//jQuery(‘.test-shortcut’).text(keyboardMap[e.which]+’ ‘);
if(e.ctrlKey){
if(randitem.id==15){
if(e.which==109 || e.which==189 || keys[189] == true){
keys[189] = true;
keys[17] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
else if(e.which!==ctrlkc){
keys[e.which] = true;
keys[17] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
}
else if(e.shiftKey)
{
if(e.which!==shiftkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[16] = true;
keys[17] = true;
printKeys();
pressed=true;
}
}
else if(e.altKey){
if(e.which!==altkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[17] = true;
keys[18] = true;
printKeys();
pressed=true;
}
}
else if(e.metaKey){
if(e.which!==metakc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[17] = true;
keys[91] = true;
printKeys();
pressed=true;
}
}
else if(e.which!==ctrlkc){
window.event.cancelBubble = true;
disabledEventPropagation(e);
e.preventDefault();
keys[17] = true;
keys[e.which] = true;
printKeys();
pressed=true;

}
}
else if(e.shiftKey){
if(randitem.id==15){
if(e.which==109 || e.which==189 || keys[189] == true){
keys[189] = true;
keys[16] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
else if(e.which!==shiftkc){
keys[e.which] = true;
keys[16] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
}
if(e.ctrlKey)
{
if(e.which!==ctrlkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[16] = true;
keys[17] = true;
printKeys();
pressed=true;
}
}
else if(e.which!==shiftkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[16] = true;
printKeys();
pressed=true;
}
}
else if(e.metaKey){
if(randitem.id==15){
if(e.which==109 || e.which==189 || keys[189] == true){
keys[189] = true;
keys[91] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
else if(e.which!==metakc){
keys[e.which] = true;
keys[91] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
}
if(e.altKey)
{
if(e.which!==altkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[18] = true;
keys[91] = true;
printKeys();
pressed=true;
}
}
else if(e.shiftKey)
{
if(e.which!==shiftkc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[18] = true;
keys[91] = true;
printKeys();
pressed=true;
}
}
else if(e.which!==metakc){
disabledEventPropagation(e);
e.preventDefault();
keys[e.which] = true;
keys[91] = true;
printKeys();
pressed=true;
}
}
else{
if(randitem.id==15){
if(e.which==109 || e.which==189 || keys[189] == true){
keys[189] = true;
if(e.ctrlKey){
keys[189] = true;
keys[17] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
else if(e.which!=109 && e.which!=189){
keys[189] = true;
keys[e.which] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
}
else{
keys[e.which] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}
}
else{
keys[e.which] = true;
disabledEventPropagation(e);
e.preventDefault();
printKeys();
pressed=true;
}

}
}
}
}
});
jQuery(document).keyup(function (e) {
if(testing){
var a = keyboardMap[e.which];
if(shortcutReady){
jQuery(‘#’+e.which).remove();
}

delete keys[e.which];
pressed=false;
}
});
function donetest(){
var copytext=’&#39#resultbool&#39’;
if(mac){
document.getElementById(‘home-hero’).innerHTML=’

Test Results

Control Shortcuts ‘+controlCount +’ of ‘+ controlarray.length+’

Navigating and Selecting Cells ‘+navigationCount +’ of ‘+ navarray.length+’

Pasting ‘+pastingCount +’ of ‘+ pastarray.length+’

Formatting ‘+formattingCount +’ of ‘+ formatarray.length+’

Rows & Columns ‘+rowsCount +’ of ‘+ rowarray.length+’

Formulas ‘+formulasCount +’ of ‘+ formarray.length+’

Tools ‘+toolsCount +’ of ‘+ toolarray.length+’

‘+resultbool+’

‘;
}
else{
document.getElementById(‘home-hero’).innerHTML=’

Test Results

Control Shortcuts ‘+controlCount +’ of ‘+ controlarray.length+’

Navigating and Selecting Cells ‘+navigationCount +’ of ‘+ navarray.length+’

Pasting ‘+pastingCount +’ of ‘+ pastarray.length+’

Formatting ‘+formattingCount +’ of ‘+ formatarray.length+’

Ribbon Commands ‘+ribbonCount +’ of ‘+ ribarray.length+’

Rows & Columns ‘+rowsCount +’ of ‘+ rowarray.length+’

Formulas ‘+formulasCount +’ of ‘+ formarray.length+’

Tools ‘+toolsCount +’ of ‘+ toolarray.length+’

‘+resultbool+’

‘;
}
}
function copyToClipboard(element) {
var jQuerytemp = jQuery(““);
jQuery(“body”).append(jQuerytemp);
jQuerytemp.val(jQuery(element).text()).select();
document.execCommand(“copy”);
jQuerytemp.remove();
}
function correctAnswer(keys) {
jQuery(‘#rightword’).show();
if(streak==0){
jQuery(‘#strword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#streakword” ).append( “Streak:“);
jQuery(‘#strword’)[0].remove();
jQuery(‘#strword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#strword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#right” ).append( “ Correct!“);
jQuery(‘#rightword’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#rightword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#streak” ).append( “1“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#strword’).textillate(‘out’);
jQuery(‘#streaknum’).textillate(‘out’);
jQuery(‘#rightword’).textillate(‘out’);
}
jQuery(‘#correct-item’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOutDown’,
sync: true,
callback:function(){

jQuery( “#correct” ).append( ““+rightcount+”“);
jQuery(‘#correct-item’)[0].remove();
jQuery(‘#correct-item’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOutDown’,
sync: true,
},
type: ‘char’
});
jQuery(‘#correct-item’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#correct-item’).textillate(‘out’);
rightcount++;
if(streakbool==true){
streak++;
if(streak==3){
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
callback:function(){

jQuery( “#heat” ).append( “ Heating up!“);
jQuery(‘#heatword’)[0].remove();
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
}});
jQuery(‘#heatword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#heatword’).textillate(‘out’);
}
if(streak==5){
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
callback:function(){

jQuery( “#heat” ).append( “ On Fire!“);
jQuery(‘#heatword’)[0].remove();
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
}});
jQuery(‘#heatword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#heatword’).textillate(‘out’);
}
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#streak” ).append( ““+(streak)+”“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
jQuery(‘#rightword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘out’);
}
else{
streak=1;
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){
jQuery( “#right” ).append( “ Correct!“);
jQuery(‘#rightword’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#rightword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){
jQuery( “#streak” ).append( “1“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘out’);
jQuery(‘#rightword’).textillate(‘out’);
}
streakbool=true;
var str=”;
var strong = document.createElement(‘h1′);
for (var i in keys) {
if (!keys.hasOwnProperty(i)) continue;
str+=keyboardMap[i];
if(i!==Object.keys(keys).length-1){
str+=’ + ‘;
}
}

var inhtml=document.getElementById(‘inputzones’).innerHTML;
var b=str.slice(0, -2);
document.getElementById(‘inputzones’).innerHTML = ‘

‘+randitem.description+’

‘+b+’

‘+inhtml;
donearray.splice(donearray.indexOf(randitem),1);
randitem=donearray[Math.floor(Math.random() * donearray.length)];
description.innerHTML=randitem.description;
//jQuery(‘.whitezone’).fadeIn();
// jQuery(jQuery(‘.whitezone’).get(1)).effect( “bounce”, { times: 2 },’normal’)
jQuery(‘.whitezone’).fadeIn();
jQuery(jQuery(‘.whitezone’)[0]).animate({ height: 80}, 200);
jQuery(jQuery(‘.whitezone’)[0]).animate({ height: 40}, 200);
jQuery(‘#pn’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){
jQuery( “#streak” ).append(“1 “);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#pn’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#pn’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#pn’).textillate(‘out’);
}

function incorrectAnswer(keys) {

jQuery(‘#perfectword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
callback:function(){
jQuery( “#perfect” ).append( “ “);
jQuery(‘#perfectword’)[0].remove();
jQuery(‘#perfectword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
}});
jQuery(‘#perfectword’).remove();
jQuery(‘#perfectword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#perfectword’).textillate(‘out’);
if(streak==0){
jQuery(‘#strword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#streakword” ).append( “Streak:“);
jQuery(‘#strword’)[0].remove();
jQuery(‘#strword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#strword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#rightword’).show();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

Apply Currency Format

Apply Currency Format


jQuery( “#right” ).append( “ wrong“);
jQuery(‘#rightword’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#rightword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){

jQuery( “#streak” ).append( “1“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#strword’).textillate(‘out’);
jQuery(‘#streaknum’).textillate(‘out’);
jQuery(‘#rightword’).textillate(‘out’);
}
if(jQuery(‘#heatword’).text().length>5){
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
callback:function(){

jQuery( “#heat” ).append( “ “);
jQuery(‘#heatword’)[0].remove();
jQuery(‘#heatword’).textillate({
autoStart: false,
in: {
effect: ‘tada’,
sync: true,
}});
jQuery(‘#heatword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#heatword’).textillate(‘out’);
}
jQuery(‘#wrong22’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOutDown’,
sync: true,
callback:function(){
jQuery( “#wrong33” ).append( ““+wrongcount+”“);
jQuery(‘#wrong22’)[0].remove();
jQuery(‘#wrong22’).textillate({
autoStart: false,
in: {
effect: ‘pulse’,
sync: true,
},
out: {
effect: ‘fadeOutDown’,
sync: true,
},
type: ‘char’
});
jQuery(‘#wrong22’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#wrong22’).textillate(‘out’);
wrongcount++;
if(streakbool==false){
streak++;
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
callback:function(){
jQuery( “#streak” ).append( ““+(streak)+”“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
}});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘fadeOut’,
sync: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘out’);
}
else{
streak=1;
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
callback:function(){

jQuery( “#right” ).append( “ wrong“);
jQuery(‘#rightword’)[0].remove();
jQuery(‘#rightword’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
},
type: ‘char’
});
jQuery(‘#rightword’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘fadeOut’,
shuffle: true,
callback:function(){

jQuery( “#streak” ).append( “1“);
jQuery(‘#streaknum’)[0].remove();
jQuery(‘#streaknum’).textillate({
autoStart: false,
in: {
effect: ‘fadeIn’,
sync: true,
},
out: {
effect: ‘hinge’,
shuffle: true,
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘in’);
},
},
type: ‘char’
});
jQuery(‘#streaknum’).textillate(‘out’);
jQuery(‘#rightword’).textillate(‘out’);
}
streakbool=false;
var str=”;
var br=”;
var strong = document.createElement(‘h1’);
//alert(Object.keys(keys).length);
for (var i in keys) {
if (!keys.hasOwnProperty(i)) continue;
//alert(‘2’);
str+=keyboardMap[i];
if(i!==Object.keys(keys).length-1){
// alert(‘1′);
str+=’ + ‘;
}
}

randitem.keys.forEach(function(i) {
if(keys[i]){
br+=’‘+keyboardMap[i]+’‘;
}
else{
br+=keyboardMap[i];
}
//alert(br);
br+=’ + ‘;
});
var k=br.slice(0,-2);
var inhtml=document.getElementById(‘inputzones’).innerHTML;
//alert(str);
var b=str.slice(0, -2);

document.getElementById(‘inputzones’).innerHTML = ‘

‘+inhtml;
jQuery(‘.whitezone’).fadeIn();
jQuery(jQuery(‘.whitezone’)[0]).animate({ height: 80}, 200);
jQuery(jQuery(‘.whitezone’)[0]).animate({ height: 40}, 200);
//jQuery(jQuery(‘.whitezone’).get(1)).effect( “bounce”, { times: 2 },’normal’)

donearray.splice(donearray.indexOf(randitem),1);
randitem=donearray[Math.floor(Math.random() * donearray.length)];
description.innerHTML=randitem.description;

//keys={};
}
function printKeys() {
jQuery(‘.test-p’).text(”);
//jQuery( “.shortcutter”).remove();
//jQuery( “.shortcut”).remove();
//jQuery(‘.test-shortcut’).text(‘Correct!’);
jQuery(‘.shortcut’).textillate({
autoStart: true,
in: {
effect: ‘pulse’,
sync: true,
},
type: ‘char’
});
var html = ”;
var summ=[];
if(donearray.length){

for (var i in keys) {
if (!keys.hasOwnProperty(i)) continue;
summ.push(i);
}
var result=false;
if(randitem.keys.sort().toString()==summ.sort().toString())
{
result=true;
}
if(result){
if(formatarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
formattingCount+=1;
}
else if(navarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
navigationCount+=1;
}
else if(controlarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
controlCount+=1;
}
else if(ribarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
ribbonCount+=1;
}
else if(rowarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
rowsCount+=1;
}
else if(formarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
formulasCount+=1;
}
else if(toolarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
toolsCount+=1;
}
else if(pastarray.filter(function(a){ return a.keys.sort().toString() == summ.sort().toString() })[0]){
pastingCount+=1;
}
result=null;

if(shortcutReady){
//alert(‘1’);
shortcutReady=false;
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘Correct! ‘;
jQuery(‘.blink-result’).textillate({
autoStart: true,
in: {
effect: ‘pulse’,
sync: true,
},
type: ‘char’
});
function ready1(newkeyss){
//alert(‘2’);
shortcutReady=true;
needclear=true;
jQuery( “.shortcutter”).remove();
jQuery( “.shortcut”).remove();
jQuery(‘.test-p’).text(‘|’);
jQuery( “.blink-result”).remove();
correctAnswer(newkeyss);
//alert(Object.keys(keys).length);
}
var newkeys=keys;
var _x1 = function(){
ready1(newkeys);
};
keys={};
window.setTimeout(_x1, 1000);
}

resultbool+='[‘+randitem.src.replace(‘.png’,”).replace(‘/wp-content/uploads/2016/02/’,”)+’]0′;
}
else{

if(shortcutReady){
//alert(‘2’);
shortcutReady=false;
document.getElementsByClassName(‘test-shortcut’)[0].innerHTML+= ‘Incorrect ‘;
jQuery(‘.blink-result’).textillate({
autoStart: true,
in: {
effect: ‘pulse’,
sync: true,
},
type: ‘char’
});
function ready(newkeyss){
shortcutReady=true;
needclear=true;
jQuery( “.shortcutter”).remove();
jQuery( “.shortcut”).remove();
jQuery(‘.test-p’).text(‘|’);
jQuery( “.blink-result”).remove();
incorrectAnswer(newkeyss);
}
var newkeys=keys;
var _x = function(){
ready(newkeys);
};
keys={};
window.setTimeout(_x, 1000);
}

resultbool+='[‘+randitem.src.replace(‘.png’,”).replace(‘/wp-content/uploads/2016/02/’,”)+’]1′
}
if(donearray.length<2){ //alert(Object.keys(keys).length); jQuery('#count').text('20 of 20'); description.innerHTML=randitem.description; donearray.splice(donearray.indexOf(randitem),1); jQuery('.test-img').attr('src',randitem.src); count--; window.setTimeout(function() { donetest(); }, 3000); jQuery('#count').text('20 of 20'); } else{ //alert(Object.keys(keys).length); jQuery('.test-img').attr('src',randitem.src); } count++; jQuery('#count').text(count); //keys={}; //alert(Object.keys(keys).length); } } function disabledEventPropagation(e){ if(e){ if(e.stopPropagation){ e.stopPropagation(); } else if(window.event){ window.event.cancelBubble = true; } } } [/script] [/inline]

Instructions

This test will evaluate your knowledge of Excel shortcuts.

You will be presented with a number of Excel commands. Enter each command’s shortcut exactly as you would when working in Excel.

If you don’t know a shortcut, type any key to continue to the next command.

Choose your Excel version to start the test!

Note: This app is not compatible with tablets or smartphones