Find Complete and recently updated Correct Question and answers of Excel. All Answers updated regularly with new questions. Upwork Excel test answers of 2016.
Python
PHP
CSS
android
html5
SEO
Javascript
Adobe Photoshop
Wordpress
Perl
Joomla
Twitter Bootstrap
EX4
Magento
Ruby on Rails
jQuery
Drupal
C Programming
C++
C#
MYSQL
Node.js
Django
CCNA
JSON
JAVA
Ajax
Question:* A user can sort a maximum of...
Answer: • Infinite columns
Question:* How do you make sure that a formula's result will always fit into the cell?
Answer: • Set the cell's format to "Shrink to fit".
Question:* True or False: There are three worksheets with every new workbook. You can change that automatic number if you want to.
Answer: • True
Question:* To get all rows and columns of data to print on one sheet, you can adjust the page breaks in Page Break Preview or:
Answer: • Select File, Print, Fit Sheet on One Page
Question:* What is the correct syntax for typing a function into a cell?
Answer: • Equals sign, function name, arguments
Question:* Which formula correctly references cell A1 on Sheet2?
Answer: • =Sheet2!A1
Question:* To view a cell comment, do which of the following?
Answer: • position the mouse pointer over the cell
Question:* Does delete button remove cell?
Answer: • NO, it clears cell contents
Question:* In a large data set with 121,005 rows, You are on the top row (row 1) of the data set. What is the fastest way to get to row 121,005?
Answer: • ctrl + down arrow
Question:* Which keyboard shortcut pastes copied information?
Answer: • Ctrl + v
Question:* How many sheets are there in Excel Workbook by default?
Answer: • 3
Question:* You can use the formula pallette to...
Answer: • create and edit formula containing functions
Question:* How do you create Word Art?
Answer: • On the Insert tab, in the Text group, click WordArt
Question:* Which of the following formulas will Excel NOT be able to calculate?
Answer: • =SUM(Sales)-A3
Question:* What is the correct formula to calculate the total of cell B3 and B4?
Answer: • =SUM(B3:B4)
Question:* Which worksheet function returns the F probability distribution?
Answer: • FDIST
Question:* Which of the following formulas is not entered correctly?
Answer: • 98-B11=
Question:* You can change the color of the following in Excel:
Answer: • All Listed
Question:* True or False: A sparkline usually shows trend information.
Answer: • True
Question:* What is the home position in an Excel worksheet?
Answer: • A1
Question:* You can convert your Excel document into a Google doc.
Answer: • True
Question:* In order to change page margin, which menu would you choose to select "Margins"?
Answer: • Page Layout
Question:* Each Excel file is called a workbook because
Answer: • It can contain many sheets including worksheets and chart sheets
Question:* True or false: To change column width in MS Excel, put cursor on the right side of the cell in that column, in the first row. Click and hold and drag to desired width.
Answer: • True
Question:* Clipart can be found under what menu?
Answer: • Insert
Question:* What is a cell?
Answer: • The intersection of a column and row.
Question:* True or False: You can create a two-input data table.
Answer: • True
Question:* A collection of worksheets contained within a single file is called a ____ .
Answer: • Workbook
Question:* In order to multiply items in Excel, you would use which symbol?
Answer: • *
Question:* You can embed Tables from Excel in:
Answer: • Both
Question:* Where can you insert a text box in Excel?
Answer: • Anywhere
Question:* What does Live Preview allow the user to do?
Answer: • See how a new font, font size, table size, or cell size will look on selected data before it applies
Question:* What is one way to get a new workbook?
Answer: • File, New
Question:* Can Excel spreadsheets contain images?
Answer: • Yes
Question:* How do you create a table on excel?
Answer: • insert>table
Question:* True or False: You can customize your toolbars and menus.
Answer: • True
Question:* Can you save a .xlsx file as a .xls file?
Answer: • Yes
Question:* Is there a way to share your spreadsheet and allow someone to change it?
Answer: • Yes
Question:* How does one change the font style of the selected cell to *bold*.
Answer: • (Ctrl+B)
Question:* Each location in an Excel spreadsheet is called a:
Answer: • Cell
Question:* What-If analysis functionality in Excel includes:
Answer: • All of these
Question:* Which of the following is not a term of MS-Excel?
Answer: • Document
Question:* Which of the following is NOT a way to align a cell?
Answer: • Align Reverse
Question:* Which types of charts can excel produce?
Answer: • Bar charts, line graphs and pie charts
Question:* Can you create Macros on excel?
Answer: • true
Question:* What does the function DATE(year, month, day) do?
Answer: • Creates a date value for the date represented by the year, month, and day arguements
Question:* Currency figures in Excel can be changed from US Dollars to the:
Answer: • All Listed
Question:* What is the short cut for saving a file in Excel?
Answer: • Ctrl + S
Question:* Excel can retrieve external data from which of the following sources?
Answer: • All of these
Question:* In order to multiply items in Excel, you would use which symbol?
Answer: • *
Question:* The following functions are listed when the office button is selected:
Answer: • all of these are functions
Question:* What does the Excel function Lookup & Reference do?
Answer: • Look up and return data matching a set of specified conditions from a range
Question:* What does the function FV stand for?
Answer: • Future Value
Question:* What is one way to get a new workbook?
Answer: • File, New
Question:* True or False: Excel has the capability to sort horizontally from left to right or right to left.
Answer: • True
Question:* The standard name of each cell is based on its ___________ and __________
Answer: • Row and column
Question:* To delete an embedded object,
Answer: • select it and then press the delete key
Question:* Which of the following formats can you decide to apply in the AutoFormat dialog box?
Answer: • All of these
Question:* Which of the following is a "Lookup and Reference" function?
Answer: • VLookup
Question:* Which types of charts can excel produce?
Answer: • Bar charts, line graphs and pie charts
Question:* True or False: Formulas can be edited across multiple worksheets at the same time.
Answer: • True
Question:* A formula in Excel must begin with the operator:
Answer: • =
Question:* Is it possible to determine the day of the week for a particular date?
Answer: • Yes, Excel offers several ways of doing so.
Question:* a formula is always started with what symbol?
Answer: • =
Question:* True or False: A Name can be applied to a single cell or a range of cells.
Answer: • True
Question:* What company distributes Excel?
Answer: • Microsoft
Question:* Where do you find the picture icon?
Answer: • The insert tab.
Question:* What does a formula usually start with?
Answer: • =
Question:* True or False: Charts from Excel can be pasted into Power Point.
Answer: • True
Question:* Each Excel file is called a workbook because
Answer: • It can contain many sheets including worksheets and chart sheets
Question:* Formulas in excel start with?
Answer: • =
Question:* In the formula =sum(B1:B5), what does the ":" represent?
Answer: • All numbers between (if applicable)
Question:* Can you add borders to cells without having a border for the workbook?
Answer: • Yes, individual cells or a collection of them can have borders.
Question:* It is possible to password protect content of selected cells so that cannot be modified
Answer: • True
Question:* Can you print only a selected part of your workbook?
Answer: • Yes, you can control what part of the workbook is printed.
Question:* True or False: It is possible to have a folder of templates in Excel to make it easier to access them.
Answer: • True
Question:* True or False: You can protect a single worksheet and leave the others with full access.
Answer: • True
Question:* Can you insert images from ClipArt into Excel?
Answer: • Yes
Question:* What do you use to create a chart?
Answer: • Chart Wizard
Question:* What is the formula used to multiply cell A1 by cell C1?
Answer: • =A1*C1
Question:* Cell A1 contains the formula =$F$39. Copying that formula to cell B2 will result in:
Answer: • =$F$39
Question:* True or False: Excel has trigonometry functions built into it.
Answer: • True
Question:* Is it possible to sort by the color of a cell in the most recent version of excel?
Answer: • Yes
Question:* How do you change text's alignment within a cell?
Answer: • Select the cell and click the appropriate alignment button in the alignment group on the Home tab
Question:* How many conditions can be set for an individual cell's conditional formatting?
Answer: • Any of these
Question:* You can sort rows by:
Answer: • All listed are correct
Question:* The functions AVERAGEIF and SUMIF both use cell values that match specified criteria.
Answer: • True
Question:* Are you able to do spell check in Excel?
Answer: • Yes
Question:* What happens when you double click on a cell?
Answer: • It become editable
Question:* How do you view the 5th decimal place when calculating costs?
Answer: • Increase the decimal to 5 digits.
Question:* True or False: When you record a macro in Excel, you are actually creating a VBA program.
Answer: • True
Question:* True or False: A pivot table is a "dynamic summary report generated from a database."
Answer: • True
Question:* If you want to set the print area which ribbon should you use?
Answer: • PAGE LAYOUT
Question:* True or False: It is possible to access Outlook, Word or other Microsoft products through Excel.
Answer: • True
Question:* A ________________ consists of a grid made from columns and rows?
Answer: • Spreadsheet
Question:* Pressing CTRL-Home moves the cursor to:
Answer: • cell a1
Question:* It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?
Answer: • Yes
Question:* Can a macro save a file?
Answer: • Yes
Question:* True or False: You can add new commands to the QAT.
Answer: • True
Question:* How do you close a formula?
Answer: • )
Question:* True or False: You can create a connection to a SQL Server Analysis Services Cube in Excel.
Answer: • True
Question:* Can the Match & Index Functions be combined together to perform a lookup?
Answer: • Yes
Question:* How do you ensure that the person using a spreadsheet can always see the column headings?
Answer: • Use Freeze Panes or Freeze Top Row.
Question:* Can Excel spreadsheets contain images?
Answer: • Yes
Question:* If you have an error, how can you find ways to fix it?
Answer: • Left click on the triangle, pause until you see a question mark, click on the arrow, and scroll to " Help on this error."
Question:* True or False: Excel will recognize patterns in data and automatically enter formulas where the patterns continue.
Answer: • True.
Question:* How do you change text's alignment within a cell?
Answer: • Select the cell and click the appropriate alignment button in the alignment group on the Home tab
Question:* How many sheets are there in Excel Workbook by default?
Answer: • 3
Question:* True or False: A Name can be applied to a range of non-contiguous cells.
Answer: • True
Question:* Which one of the following formulas cannot be calculated by Excel?
Answer: • =SUM(Sales)-A3
Question:* You can sort rows by:
Answer: • All listed are correct
Question:* You have two columns summing your account totals. The first column looks exactly right but the second one is not displaying the way you want. How do you make the two columns look the same?
Answer: • Copy the first column. Select the second column. Use "Paste Special" to paste "Formats".
Question:* Is SmartArt available in Excel?
Answer: • Yes
Question:* A ________________ consists of spreadsheets.
Answer: • workbook
Question:* True or False: The value in a cell that contains the formula =RAND() changes every time any change is made to the workbook.
Answer: • True
Question:* Data can be arranged in a worksheet in an easy to understand manner by
Answer: • All of these
Question:* How does one save the active workbook without altering the file or folder name.
Answer: • Click save button (on top of home)
Question:* Cells D3 through Z3 list sales total for various months. What does the equation "=SUM(D3:Z3)" show?
Answer: • Total sales for all the months in D3 through Z3.
Question:* True or False: You can convert an existing shape to a Freeform Shape.
Answer: • True
Question:* How would you rename the tabs at the bottom of the spreadsheet?
Answer: • Both ways: right click on tab and type new name or double click tab and type new name.
Question:* What is a logical function?
Answer: • A function that works with statements that are either true or false
Question:* A pivot table allows you to:
Answer: • Create a worksheet with data using a filtering window where you can include or exclude desired fields of the original table
Question:* Which keyboard shortcut copies cell data?
Answer: • Ctrl + c
Question:* True or False: You can save any Excel document as a web page.
Answer: • True
Question:* Which is a type of operator?
Answer: • All of these
Question:* What happens when you double click on a cell?
Answer: • It become editable
Question:* What is the purpose of the Σ button?
Answer: • Totaling a column or row
Question:* If you want to highlight a row of numbers by less than, greater than or equal to, what should you use?
Answer: • Conditonal Formatting
Question:* True or False: It is possible to sort information both vertically (by columns) and horizontally (by rows)
Answer: • True
Question:* True or false? The Quick Access Toolbar (QAT) is useful for adding popular commands.
Answer: • True
Question:* How do you insert saved images?
Answer: • Choose Insert/Picture
Question:* Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?
Answer: • The formatting for grid lines isn't set on the cell.
Question:* Identify the error: When entering 325 in a cell, the result shows up as 3.25.
Answer: • Fixed Decimal mode is turned on.
Question:* True or False: Once cells are merged in Excel, they can never be un-merged.
Answer: • False
Question:* Cells B3 through B121 list several values. What equation shows the average of those values?
Answer: • =AVERAGE(B3:B121)
Question: