Excel Essential Training Exam 34 Questions with Verified Answers,100% CORRECT

Excel Essential Training Exam 34 Questions with Verified Answers In Excel, a file is a ____________. - CORRECT ANSWER workbook You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - CORRECT ANSWER now says "dog" The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into the formula bar). - CORRECT ANSWER use the function SUM, type an open parenthesis, and the highlight the five cells What is true of formatting cells to a particular category, such as Accounting or Currency? - CORRECT ANSWER This adjusts the display of your data, but not the data itself When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. - CORRECT ANSWER simply complete the action. Excel maintains the formulas for you Which of the following is not type of Sparkline (mini chart)? - CORRECT ANSWER Scatter _____ means "exact match" when creating a VLOOKUP. - CORRECT ANSWER FALSE If you highlight a column and then click the Sort alphabetically button (A-Z), - CORRECT ANSWER only the data in the column is sorted All of the following are required to begin creating a PivotTable, except: _____. - CORRECT ANSWER Begin with an equal sign and open parenthesis A macro is a way to automate a sequence of steps in your work. - CORRECT ANSWER true Excel is _____. - CORRECT ANSWER all of these answers You highlight a column of data in a worksheet. In the status bar below, you'll see all of the following by default, except: _____. - CORRECT ANSWER Minimum and Maximum values You can create a new workbook by pressing Ctrl+n on your keyboard, or for a greater variety of options, - CORRECT ANSWER navigating to File New Date entries are numbers and, by default, - CORRECT ANSWER lined up on the right side of the cell Save is a safer way to save your work than Save As. - CORRECT ANSWER False When you copy a formula into an adjacent cell, Excel will adjust the corresponding columns/rows to fit that cell. - CORRECT ANSWER true How can you access font styles and effects other than what is presented by default on the Home ribbon tab? - CORRECT ANSWER click the dialog box launcher in the bottom right-hand corner of the Font section How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? - CORRECT ANSWER highlight only the data where you'd like to insert a row. Right-clickInsert...Shift cells down All of the following are ways to print your spreadsheets with greater efficiency, except: - CORRECT ANSWER Remove all headers and footers To create a chart, you begin by _____. - CORRECT ANSWER selecting data Which of the following is not type of Sparkline (mini chart)? - CORRECT ANSWER Scatter To see multiple worksheets from different files at once, - CORRECT ANSWER Click on the view tab Arrange All A fast way to make a copy of a sheet in the same workbook is to drag the sheet tab with the _____ key held down. - CORRECT ANSWER CRTL When creating an IF function, a _____ separates the "logical test" from the "value if true/false". - CORRECT ANSWER comma _____ means "exact match" when creating a VLOOKUP. - CORRECT ANSWER FALSE If you lock a cell and then protect the worksheet, _____. - CORRECT ANSWER the cell cannot be edited by others. Workbooks containing _____ cannot be shared. - CORRECT ANSWER tables If you highlight a column and then click the Sort alphabetically button (A-Z), - CORRECT ANSWER only the data in the column is sorted. There are unique filtering options for text and number entries. - CORRECT ANSWER true Data validation allows you to _____. - CORRECT ANSWER restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.). Goal Seek is a tool that - CORRECT ANSWER allows you to see how changing one data item in a formula affects the others ll of the following are required to begin creating a PivotTable, except: _____. - CORRECT ANSWER Begin with an equal sign and open parenthesis. Slicers provide you with _____ for filtering PivotTable data and visualizing what you have filtered. - CORRECT ANSWER buttons A macro is a way to automate a sequence of steps in your work. - CORRECT ANSWER true