Wall Street Prep Excel Exam Questions with 100% Correct Answers (Latest 2023)

Average Function Correct Answer Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function Correct Answer Definition: A function that returns one value when a condition you specify evaluates to true and a diff...

=AVERAGE(number1,[number2],...) Correct Answer Average Function =IF(logical test, [value if true], [value if false]) Correct Answer Simple IF Function =IFS(logical test n, value if true n, value if false n) Correct Answer IFS Function =IFERROR(value, value_if_error) Correct Answer IFERROR F...

Add/delete sheets Correct Answer alt-i-w OR alt h-i-s Moving around task ribbon Correct Answer Tab and shift (to select) Auto fit cell Correct Answer alt-h-o-i Custom fit columns Correct Answer alt h-o-w Custom fit rows Correct Answer alt h-o-h Select entire column/row Correct Answer ...

Add/delete worksheets Correct Answer alt i w Move back and forth to different worksheets Correct Answer ctrl page up and down Open a new file Correct Answer alt f n, ctrl n open a file Correct Answer alt f o, ctrl o save a file Correct Answer alt f s, ctrl s, alt f a(save as) print a ...

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w Incorrect Correct Answer Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a workbo...

What is the keyboard shortcut to move sheets within a workbook? Correct Answer Alt H O M What is the keyboard shortcut to open the formatting cells dialog box? Correct Answer Ctrl 1 What are the keyboard shortcuts for auto-fitting a range of columns? Correct Answer 1. Select the columns by hit...