EXCEL CERTIFICATION EXAM|ACTUAL QUESTIONS AND ANSWERS LATEST UPDATE|100% CORRECT

EXCEL CERTIFICATION EXAM|ACTUAL QUESTIONS AND ANSWERS
LATEST 2024-2025 UPDATE|100% CORRECT



100%




Next steps




Your answers




1 of 79

Definiti
on

developer > macros, select macro > edit > copy code from one to
another > file > close and return



Give this one a try
later!

, unlock cells / protect sheet modifying macros using VBA




recording
macros create a combination Chart


Don't know?




2 of 79

Definition



file > middle of screen > protect wb > encrypt (with password



Give this one a try later!



create a combination chart create a pivot table




encrypt a
workbook mark a workbook as
final


Don't know?




3 of 79

Definition



home> format as table

,Give this one a try later!


apply table style to cell range sort the data in the selected cells




remove formatting from the
selected cells filter the data in the selected cells


Don't know?




4 of 79

Definition



RC surface tab>hide
file>options>advanced, display options>show sheet tabs



Give this one a try later!



hide or unhide a worksheet
merge multiple sheets into
one / tabs




duplicate a worksheet within
the workbook change the color of sheet tabs



Don't know?




5 of 79

, Definition



how many cells have numbers in it?
COUNT(cell #, cell #...)


Give this one a try later!



count function count numbers




statistical
functions average function


Don't know?




6 of 79

Definition



F: looks for a given character
FIND("char wanted",cell name)
L/R: returns text starting from left side
LEFT(cell #, # of char wanted)
actual use: LEFT(cell number, FIND("char wanted",cell name)



Give this one a try later!



Find, left,right fxns Date and time functions