Excel Assessment - Practice

What are the most important data types in Excel, and how are they used?

The most used Excel data types are Number, Percentage, Date and Text.

Can we find a maximum or minimum Value of sales order with the help of subtotal? a)Yes b)No

a

How can we apply grouping and calculate the sum of the groups at the same time? a)With the help of Subtotal in Data Tab b)With the help of What if analysis in Data Tab c)With the help of Advance Flter in Data Tab d)With the help of Trace Precedent in Formula Tab

a

How can you insert a new table row, when active cell is the rightmost cell on last column of an Excel table? a)Press the Tab Key b)Press the Enter Key (return) c)Press the Esc d)Press the spacebar

a

How to navigate of a cells which are used in a Formula for Calculation and highlight them with an arrows? a)Trace Precedent b)Trace Dependent c)Show Formulas d)Error Checking

a

Mikhala made some changes to a workbook called "Sept 2014". She then clicked Save As, typed "Sept_2014_New" in the File Name box and clicked Save. Which of the following statements are true? a) The changes Lucy made to "Sept 2014" will be reflected in the new workbook, "Sept_2019_New" only. b) The changes Lucy made will be reflected in both versions, "Sept 2014" and "Sept_2019_New". c) By using the Save As function Lucy replaced the file "Sept 2014" with "Sept_2019_New". The original file no longer exists. d) The changes Lucy made will stay in "Sept 2014" and will not be reflected in "Sept_2019_New".

a

VLOOKUP can only look for value on which side of identifier column: a)Left b)Right c)Left but with some alteration to the formula d)Not Applicable

b

What is the keyboard shortcut for reversing (undoing) your last action? a) Ctrl+U b) Ctrl+Z c) Ctrl+X d) Ctrl+Y

b

What is the keyboard shortcut to select a row of active cells? a) Ctrl + Spacebar b) Shift + Spacebar c) Shift + End d) Ctrl + End?

b

Which of the following functions is NOT associated with the Review Tab on the Ribbon? a) The spelling checker. b) The sort data function. c) The comment function. d) The track changes function.

b

Why you might consider pressing F4 key three times after selecting a cell reference. a)Absolute reference for row only. b)Absolute reference for Column only c) Absolute reference for a cell d)None of the above

b

What is the order of operations used when evaluating formulas in Excel?

A formula, using below sequence PEMDAS

What is the difference between Excel for desktop and Excel 365?

Desktop is the newest version of the Office productivity suite (Word, Excel, PowerPoint and other application), typically accessed via the desktop. Office 365 is a cloud-based subscription to a suite of programs including Office 2016. Office files can be accessed in the browser and on Mobile devices, which allows you more flexibility.

What is a function in Microsoft Excel?

Functions are predefined formulas and are already available in Excel. Formulas in Excel are useful to perform various mathematical, statistical, and logical operations. If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula. After the =, what comes next depends on what you're trying to do.

What are the most typically used functions in Microsoft Excel?

One of the most useful Excel functions is SUM, which allows you to quickly to sum a range of cells by using AutoSum button. Other useful Excel functions that are very commonly used are are AVERAGE, MAX and MIN. As well as forms and tables are created often through Excel.

What happens when you press the shortcut combination Ctrl+i while you have cells, containing content such as text or numbers, selected? a) This italicizes the selected content. b) This launches the Excel Information and Help dialogue box. c) This inserts a new row or column depending on the selection. d) This hides the selected cell range.

a

Which option will be used to split first name and last name in separate Columns? a)Text to Columns b)Substitute Function c)Find Function d)Lookup Function

a

Why $ sign is used with Column or Row in a cell reference? (as mention in the below picture $F$3) a)Cell lock b)Column lock c)Row lock d)None of the above

a

A client emails you and informs you that they were unable to open a workbook you sent them as they still use MS Excel 2010. Which of the following options will quickly resolve this issue and allow the client to open the workbook? a) They will need to install MS Excel 2010 or use someone else's software in order to open the workbook. b) You can use the Save As function to select a Save As Type: Excel 2010 Workbook. c) If you open the workbook, you can go to the client and copy and paste all the content into their version of Excel. d) If you rename your workbook: "Excel 2003", this will allow the client to open the file.

b

For finding best results in approximate match we have to sort the data by which order? a)Descending b)Ascending c)Both d)Neither

b

How to navigate a dependency of the any cell and highlight it with an arrows? a)Trace Precedent b)Trace Dependent c)Show Formulas d)Error Checking

b

Jason has a workbook open that his colleague created. The workbook is titled: "Management Budget". John wants to use this workbook as a base for creating a workbook called "Project Management". Which of the following is the correct sequence of actions for him to take? a) File Tab - Save - File Name - "Project Management" - Save. b) File Tab - Save As - File Name - "Project Management" - Save. c) File Tab - Open - File Name - "Project Management" - Open. d) File Tab - Save As - File Name - "Management Budget" - Save as Type - "Project Management".

b

Select which of the following lists most accurately represent functions found in the Backstage View in Excel: a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review. b) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print and Options. c) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and Access. d) None of the above lists are entirely correct.

b

Through which tab we can insert a background image? a)Home Tab b)Page layout Tab c)View Tab d)Formula Tab

b

How to add custom list in excel, so then we can use it repeatedly? a)File > Options > General > Default Program > Edit Custom List b)File > Options > Formulas > Calculation option > Edit Custom List c)File > Options > Advanced > General > Edit custom List d)File > Option > Add-In > Edit Custom List.

c

Most workbooks in Excel contain multiple worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following is the keyboard shortcut to for switching between worksheets in Microsoft Excel? a) Alt+Tab b) Alt+PgDn/PgDn c) Ctrl+PgDn/PgUp d) Ctrl+UpArrow/DownArrow

c

Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse. What is a shortcut for quickly selecting a range of contiguous columns? a) Select the first column. Hold down Ctrl and press the right arrow on the keyboard. b) Select the first column. Hold down Ctrl and drag the mouse cursor towards the right. c) Select the first column. Hold down Shift and press the right arrow on the keyboard. d) All of the above options are correct.

c

The following shortcut key combinations will allow you to Open, Close and create a New workbook, respectively: a) Pressing Alt + O to Open, Alt + C to Close, Alt + N for New. b) Pressing Control + O for Open, Control + C for Close, Control + N for New. c) Pressing Control + O for Open, Control + W for Close, Control + N for New. d) None of the above options are correct.

c

What happens when you select cells and press Ctrl+2? a) Text in the selected cells are underlined. b) Italic formatting is applied to the text in the selected cells. c) Bold formatting is applied to the text in the selected cells. d) A duplicate of the selected cells will be inserted directly below the selection.

c

When editing a cell, which key or combination of keys can you press to toggle between relative, absolute and mixed cell references? a)CTRL+SHIFT+F4 (Windows) or Command+ Shift+4 (Mac) b)ALT + SHIFT + F4 (Windows) or Option + Shift + 4 (Mac) c)F4 (Windows) or Command + T (Mac) d)ALT + F4 (Windows) or Option + F4 (Mac)

c

Which function would you choose from below to round up a value to the nearest increment of your choice like for instance up to next 5? a)ROUND UP b)MAX c)CEILING d)ROUND

c

Which of the following functions are you likely to find under the Insert tab on the Ribbon? a) Insert a page break. b) Insert a formula. c) Insert a table. d) Insert track changes.

c

Which shortcut key combination can be used to insert the current date into a cell? a) Ctrl+D b) Ctrl+Shift+; (Control+Shift+semicolon) c) Ctrl+; (Control+semicolon) d) Ctrl+Shift+D

c

Why you might consider pressing F4 Fey two times after selecting a cell reference? a)Cell lock b)Column Lock c)Row lock d)None of the above

c

Allen is using a colleague's PC. He is curious as to how much his colleague earns and when he sees a folder with the title "Budget", he decides to snoop. He opens the folder and views a few of the workbooks in this folder. Will his colleague be able to know he snooped, and if yes, how? a) No, Ben is safe. Unless his colleague is an IT specialist, he will never find out. b) Yes, if his colleague presses the Data tab on the Ribbon, this will reveal a list of recently displayed documents. c) No, Excel automatically deletes recently access workbook and file history if you close and shutdown the PC. d) Yes, if his colleague opens the Backstage View and go to the Recent Workbooks and Recent Places area.

d

How to apply Header or footer on the page which will be used in printing? a)Page Break b)Print Area c)Margin d)Page Setups

d

The Recent Workbooks list located in the Backstage View shows all workbooks recently opened. What action can I take to ensure a workbook remains on this list regardless of how many workbooks I opened subsequent to opening this workbook? a) I can save the Workbook to the Recent Workbooks folder. b) By adding the Workbook to My Favorites on the Quick Access Toolbar. c) The Recent Workbooks list automatically keeps all workbooks that have been opened and I do not need to do anything. d) By 'pinning' the workbook to the Recent Workbooks list by clicking the pin icon located next to it.

d

What is the shortcut key to save a workbook? a) Ctrl+Enter b) Ctrl+Shift+S c) Alt+S d) Ctrl+S

d

Which of the following statements about the Print Preview is true? a) It allows you to view what your document will look like before you physically print the pages. b) You access the Print Preview area of the by pressing: Control + P. c) You access the Print Preview area by clicking on the File button to go to the and then on the Print button. d) All of the above statements are correct.

d

Which tool would allow you to set a cell in a such a way that the date entered would only be between a given range? a)A Protect Workbook b)Protect Worksheet c)Filter d)Data Validation

d