Excel 2016 Assessment Test

Ace your homework & exams now with Quizwiz!

If you want to make a cell reference in formula absolute,what character would you put in front of the row and columns name?

$ Dollarsign

Character/ Operator is used to multiply in Excel

*

What character/operator is used to divide in Excel

/

One of the options is not like the others,find the odd one out.

A = SUM (B2:B6) B = SUM ( B2,B5,B4,B1,B6) C = b2+b3+b4+b5+B6 D = Sum (B2,B6) Answer = D The Odd one is = sum ( b2,b6) as its only summing two cells.

=max

A function that finds the highest value of a group cells

How can you restrict users to only select the options from drop down on a specific cell range?

A. Conditional Formatting B Data Validation C.Protect Worksheet D.Protect Workbook Answer= B Data Validation

Which number format will display the cell A2 as January?

A. MMMM-YY B.MMMM C.MMM D.MMMMM Answer= B 4 M's

Which function will return the largest value from cell range A2:A5

A.=Maximum (A2:A5) B. =Large (A2:A5,A1) C. = Max (A2:A5) D. = Upper (A2:A5) Answer= C =Max (A2:A5)

Which chart among the options is best for showing time based data?

A.Column Chart B.Bar Chart C.Radar Chart D. Line Chart Answer = D Line Chart

How would you modify the cell so that the cell containing the value 8.856 displays as 9?

Answer = b which you should click decrease decimal button 3 times

=sum

Function is used to find the total of a group of cells.

Auto Fill

The feature that enables Excel to create a series automatically.

Merge

To combine several adjacent cells into one large cell, you used what command.

D ='VALUESHEET'!A1

Which formula can be used to get value of cell A1 from the named sheet VALUE SHEET?

c. offset

Which function can return the cell value which calculates the number of rows & columns away from base cell? ​

Wrap Text

a feature/command in Excel allow you to put extra long text into multiple lines within a cell so it be read easily

=

a formula is always started typing in.

How would you add a chart "in a cell" to show sales data from last 12months?

a.Add image of the chart in the cell b. Add comment & add chart to that c.Hyperlink to the chart on another sheet d.Add sparkline,a graphic that shows on cell graphics Answer= d

Which option can we use,if the text in cell is being cut off &we want to see all text without increasing the width of the column?

a.Wrap Text b.Wrap Column c.Change Alignment d.Fill Handle Answer= A Wrap Text

Letters

cell address start with letters.

= average

function is used to find the average of a group of cells

Landscape

if the paper is wider than it is tall,what is the orientation.

Header

text that is printed at the top of each page

Formula Bar

the area in a worksheet that shows the actual contents of current cell is.

Active Cell

the cell that is currently ready for data entry which it is called.

Sort & Filter

to put data into alphabetical order by last name (A-Z)

Scaling

what do you change so that an entire worksheet can fit on one page.

Ctrl+

what keys are pressed to show the formulas in Excel

Range

what term is used to describe a group of cells in a spreadsheet.


Related study sets

APUSH CHAPTER 5 QUIZ AMERICAN PAGENT

View Set

Muscles of the Lower Limb (Name, Action, Origin, Insertion)

View Set

Reading Quiz: Chapter 9. Businesses and the Costs of Production

View Set

Equity Securities - Practice Exam

View Set

Real Estate Finance Ch.2 The Secondary Market & The Federal Reserve System

View Set

Social Resp and Ethics Ch 1 Quizes

View Set