Microsoft Office 2016 Excel Proficiency Test (2023) | Complete Questions & Answers (100% Verified- All Correct)

Microsoft Office 2016 Excel Proficiency Test (2023) | Complete Questions & Answers (100% Verified- All Correct) Microsoft Office 2016 Excel Proficiency Test (2023) | Complete Questions & Answers (100% Verified- All Correct) Which feature could be used to print a very long single sheet of paper? - ANSWER - Scale to fit In which area can you see a preview of your worksheet? - ANSWER - Backstage view What is a selection of multiple cells called? - ANSWER - Range What is a cell address in a formula know as? - ANSWER - Cell referencing Which worksheet view shows how your worksheet will look when printed? - ANSWER - Page layout Which key can you press to switch to edit mode? - ANSWER - F2 In which view can you see the header and footer areas of a worksheet? - ANSWER - Page layout view What is the maximum number of worksheets you can include in a workbook? - ANSWER - Unlimited Which view shows you a reduced view of each page of your worksheet? - ANSWER - Page break view Part of the excel program window that displays the active cell address - ANSWER - Name box Default view in excel - ANSWER - Workbook Direction in which contents of page will print - ANSWER - Formula prefix Equal sign preceding a formula - ANSWER - Orientation File consisting of one or more worksheets - ANSWER - Cell Intersection of a column and a row - ANSWER - Normal view Item on the ribbon that opens a dialog box or task pane - ANSWER - Launcher Let's you copy cell contents or continue a series of data into a range of selected cells - ANSWER - Fill handle Let's you move or copy data from one cell to another without using the clipboard - ANSWER - Drag and drop method Displays an alphabetical list of functions from which you can choose - ANSWER - Formula Clears the contents of selected cells - ANSWER - Delete key