Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security
Which of the following is a Formula Auditing option? (9% of people got this correct)
Trace Precedents
Reconcile Totals
Conditional Formatting
What does the function =TRIM() do? (11% of people got this correct)
It rounds fractions to a specified number of decimal places
It strips out all spaces from text
It strips out extraneous spaces from before and after text
What is a Timeline? (12% of people got this correct)
A curve fitted to a set of data in an Excel chart
A log of Excel activity to allow actions to be undone or redone
A graphical way of filtering by date in a Pivot Table
What is the final argument 0 doing in this formula? =VLOOKUP(F7,B1:D5,3,0) (13% of people got this correct)
It’s an error, the formula will not work
It’s making sure the formula finds cells containing a 0 as well as a 3
It’s making sure only entries that EXACTLY match cell F7 are looked up
Why might grouping rows be preferable to hiding them? (13% of people got this correct)
Grouped rows have a symbol in the spreadsheet margin so it is clear when they are not displayed
Rows which are not adjacent can be grouped together
Grouped rows are automatically assigned a group ID, making reference to them easy
What is the syntax of the IF(A,B,C) function? (14% of people got this correct)
A and B are tested for equality, C is the result if they are equal
A is the condition, B is the result if the condition is not met, C is the result otherwise
A is the condition, B is the result if the condition is met, C is the flag for Boolean algebra
How could you ensure users entered only days of the week into a cell? (17% of people got this correct)
Use the function =WEEKDAY()
Format the cell as a custom date of syntax ddd
Define a Data Validation List consisting of weekdays
What would the formula =SUMIF(A1:A10,"Village",B1:B10) do? (22% of people got this correct)
It adds together the numbers in the ranges A1:A10, B1:B10 and the named range “Village”
For rows where column B cells contain the word Village, it adds up the numbers in column A
For rows where column A cells contain the word Village, it adds up the numbers in column B
What would have to have been set before the formula =SUM(Grid) would work? (22% of people got this correct)
A function called Grid, referring to some cells
An absolute reference called Grid, referring to some cells
A named range called Grid, referring to some cells
What does the character ^ do in an Excel formula? (23% of people got this correct)
Raises a quantity to a power (e.g. 3^2 is 3-squared)
Reformat the characters following it as superscript
Force characters following it to be interpreted as text rather than a number
{"name":"Which of the following is a Formula Auditing option? (9% of people got this correct)", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Which of the following is a Formula Auditing option? (9% of people got this correct), What does the function =TRIM() do? (11% of people got this correct), What is a Timeline? (12% of people got this correct)","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Yeehaw Final Exam
100
Hey, Happy MSCI Birthday! This year’s Christmas party will be special not only because of the glamorous Casino Royale theme of the event but also as we are celebrating the 10th anniversary of the Budapest Office. In 2007 MSCI first opened its doors in Budapest with only three employees and now a decade later we are more than 370 settled on 4,530 square meters at Green House. To warm up for this outstanding event we are launching a two week long quiz tournament with fun trivia questions. Check your knowledge on MSCI, casinos and games, Hollywood celebrities and other exciting topics. And remember, all is about the number 10! Three winners will be selected randomly from those providing correct answers within the 5 minute time limit. The lucky ones will win mini Casino Sets. Let’s get started with today’s questions:
1160
Latin KS3
23120
Travel Playlist - Match the staff to their tunes!
31160
Do you have any recommendations in new papers today?
100
Dissertation
740
What is your spirit animal?
630
Does Your 3 Year Old Need Occupational Therapy?
840
Neurodegenerative Diseases
35180
Does Your Home & Property Need A Clearing?   Take this short quiz to determine the level of necessity to have a Home & Property Clearing
1260
Which massage is the right one for you?
1160
Dalam 5 tahun ke depan kamu akan seperti apa
520
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker