EXCEL CRASH COURSE EXAM 2024 WITH 100% CORRECT ANSWERS

1 |uPu au gu e


EXCEL CRASH COURSE EXAM|| ALL QUESTIONS u u u u u u



AND CORRECT ANSWERS|| LATEST AND COMPLE u u u u u



TE UPDATE 2024 WITH EXPERT SOLUTIONS|| ASS
u u u u u u



URED PASS!!! u




Which of the following keys IS NOT a way to trace precedent cells?Ct
u u u u u u u u u u u u u




rl [ u




Alt m p u u u




Alt t u t u u u




Ctrl Alt [ - u u u


ANSWER: The correct answer is: Ctrl [. Ctrl [ is not a valid shortcut. Alt m p, Alt t u
u u u u u u u u u u u u u u u u u u u u


t, and Ctrl Alt [ are all shortcuts that can be used to trace precedentcells.
u u u u u u u u u u u u u u u u




What is the keyboard shortcut to freeze panes within a worksheet?Alt
u u u u u u u u u u u u




FWV u u




Alt W S A u u u




lt W F F
u u u



Alt A W T - ANSWER: The correct answer is: Alt w f f.
u u u u u u u u u u u u u




Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alta w
u u u u u u u u u u u u u u u u u u u u u


t is a shortcut to build data tables.
u u u u u u u u




Please select the answer that best describes the shortcut to
u u u u u u u u u



Split (not freeze) an excel sheet into just two panes (top and bottom)To
u u u u u u u u u u u u u




u navigate from pane to pane u u u u




1. Anywhere in the Excel worksheet hit Alt W S to split the panes to a top and bott
u u u u u u u u u u u u u u u u u u


om. 2. Hit F6 to jump from pane to pane (in some versions of Excel you willneed to
u u u u u u u u u u u u u u u u u u


hit F6 several times to get from one pane to the other).
u u u u u u u u u u u u

,2 |uPu au gu e


1. With the active cell on any row but in column A, hit Alt W S to split the panesto a t
u u u u u u u u u u u u u u u u u u u u u u


op and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you
u u u u u u u u u u u u u u u u u u


will need to hit F6 several times to get from one pane to the other).
u u u u u u u u u u u u u u



1. With the active cell on any column but in row 1, hit Alt W S to split the panes toa to
u u u u u u u u u u u u u u u u u u u u u u


p and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you wil
u u u u u u u u u u u u u u u u u u


l need to hit F6 several times to get from one pane to the other). -
u u u u u u u u u u u u u u u


uANSWER: The correct answer is: u u u u




With the active cell on any row but in column A, hit Alt w s to split the panes to atop a
u u u u u u u u u u u u u u u u u u u u u u


nd bottom. u




Hit F6 to jump from pane to pane (in some versions of Excel you will need to hitF6 se
u u u u u u u u u u u u u u u u u u u


veral times to get from one pane to the other).
u u u u u u u u u




If the active cell is not in Column A, the user will have more than 2 panes. If theacti
u u u u u u u u u u u u u u u u u u u


ve cell is in Row 1, the user will get two vertical panes.
u u u u u u u u u u u u




You are in cell A1 and start a formula by typing = in a worksheet with split top andbott
u u u u u u u u u u u u u u u u u u u


om panes. In order to jump to the bottom pane while working on the formula:
u u u u u u u u u u u u u u




Hit Tab u u



Hit F6 u




Hit Alt F6 u u




Hit Alt Tab - ANSWER: The correct answer is: Hit F6
u u u u u u u u u u



Tab will navigate to the next cell. Alt F6 is not a valid shortcut. Alt Tab willnavigat
u u u u u u u u u u u u u u u u u


e to a different window.
u u u u




See lesson: Splitting & Freezing Panes
u u u u u




Identify the commands to insert a comment and delete a comment1)Al
u u u u u u u u u u u




t e m 2) Alt e m
u u u u u u




1)Alt h e m 2) Alt I m 1 u u u u u u u u




)Shift F2 2) Alt h e m u u u u u u




1)Alt h e m 2) Alt I s - ANSWER: The correct answer is Shift F2, Alt h e m.
u u u u u u u u u u u u u u u u u u u

,3 |uPu au gu e


Alt e m is a shortcut to open the menu to move or copy a selected sheet. Alt I s isthe sh
u u u u u u u u u u u u u u u u u u u u u u


ortcut to insert a symbol. u u u u




Identify the utility used to create a dropdown menu in Excel.Alt
u u u u u u u u u u u u




dt u




Alt d v l u u u u




Alt d l u u




Alt d d t - ANSWER: The correct answer is: alt d l.
u u u u u u u u u u u u



Alt d t is the shortcut to build a data table. Alt d v l is not a valid shortcut. Alt d d tis no
u u u u u u u u u u u u u u u u u u u u u u u u u


t a valid shortcut.
u u u




Which of the following is NOT a shortcut for changing the format of a cellCtrl T
u u u u u u u u u u u u u u u u




ab
Ctrl Shift 1 u u u



Ctrl B u



Alt h f c - ANSWER: The correct answer is Ctrl Tab.
u u u u u u u u u u u




Ctrl Tab will move the selected cell. It is not a shortcut used to format cells. Ctrl Shift
u u u u u u u u u u u u u u u u u u


1 will change the cell to a Number format, Ctrl B makes the cell text bold, Alth f c will
u u u u u u u u u u u u u u u u u u u u


allow to change the text color.
u u u u u u




Identify the shortcut to remove arrows from Trace Precedents or TraceDependents
u u u u u u u u u u u


.
Alt d t u u u




Alt m p u u u




Alt m d u u




Alt m a - ANSWER: The correct answer is Alt m a.
u u u u u u u u u u u

, 4 |uPu au gu e


Alt d t inserts a data table. Alt m p is the shortcut to trace precedents. Alt m d is theshort
u u u u u u u u u u u u u u u u u u u u u


cut to trace dependents.
u u u




Identify a function in cell D6 that will return the fraction of the year elapsedassumi
u u u u u u u u u u u u u u u


ng a 360 day count basis.
u u u u u




=STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)
=YEARFRAC(D4,D5) - ANSWER: The correct answer is: u u u u u u


=YEARFRAC(D4,D5,2). STUB is not an Excel formula. DAYS360 will return thenu u u u u u u u u u u u


mber of days in a 360 day year. YEARFRAC(D4,D5) will calculate the fraction using
u u u u u u u u u u u u u u


a 365-day year.
u u




Identify the formula that will always output a date that is the end-of-
u u u u u u u u u u u u


month date 3months after the date inputted in D5.
u u u u u u u u u




=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5))
=EOMONTH(3,D5)
=EOMONTH(D5,3) - ANSWER: The correct answer is: =EOMONTH(D5,3) u u u u u u u




=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5)) will add 3 months to the datainp u u u u u u u u


utted in D5. EOMONTH(3,D5) reverses the arguments required for this function.
u u u u u u u u u u




Identify the formula that, based in user inputs in cells B1 and B2, outputs the text"ani
u u u u u u u u u u u u u u u u


mal lover" for users who have at least 1 dog and at least one cat, and outputs "lonely
u u u u u u u u u u u u u u u u u u


person" when those conditions are not met.
u u u u u u




=IF(OR(B1>0,B2>0),"animal lover","lonely person") u u




=IF(AND(B1>1,B2>1),"animal lover","lonely person") u u




=IF(AND(B1>0,B2>0),"animal lover","lonely person") u u