What is the Syntax of SUMIF

SUMIF(range, criteria, [sum_range])

A Pivot table has the following parts -

(1) Report Filter; (2) Column Labels; (3) Row Labels; (4) Values

How do you freeze panes in Excel?

View---- Windows---- Freeze Pane

Specify the order of operations used for evaluating formulas in Excel.

Bracket, Operation, Division, Multiplication, Addition, Subtraction

How will you find duplicate values in a column?

To highlight duplicate values – use Conditional Formatting

What is the use of LOOKUP function in Excel?

returns a value from a range or an array

studbud

Microsoft Excel Assessment 3

15 termsStudBud Administration

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
=AVERAGE A1:A5
=AVERAGE(A1:A4)
=AVERAGE(A1:A5)
=AVG(A1:A5)
2
What is the Syntax of SUMIF
SUMIF(range)
SUMIF(criteria, [sum_range])
SUM(range, criteria, [sum_range])
SUMIF(range, criteria, [sum_range])
3
FORMULA – is a statement which written by the user for calculations. Ex: =1+2+3
True
False
4
What is IF function in Excel
Text
Date&Time
Maths & Trig
Logical Function
5
Numeric values by default are aligned _____
Left
Center
Right
Justify
6
A Pivot table has the following parts -
1) Conditional format; (2) Column Labels; (3) Row Labels; (4) Values
(1) Report Filter; (2) Column Labels; (3) Row Labels; (4) Values
(1) Report Filter; (2) Column Labels; (3) Row Labels; (4) Sorting
(1) Report Filter; (2) Row Labels; (3) Values
7
In Excel, which one denotes a range from B1 through E5
E1$E5
E1toE5
E1-E5
E1:E5
8
How do you freeze panes in Excel?
Insert-----timeline----Freeze Pane
Home----Alignment ---- Freeze Pane
View---- Data---- Freeze Pane
View---- Windows---- Freeze Pane
9
Specify the order of operations used for evaluating formulas in Excel.
Bracket, Operation, Division, Multiplication, Addition, Subtraction
Division, Bracket, Multiplication, Order, Subtraction, Addition
Multiplication, Division, Bracket, Order, Subtraction, Addition
Bracket, Order, Multiplication, Addition, Subtraction, Division
10
How will you find duplicate values in a column?
To highlight duplicate values – use Conditional Formatting
Use data validation
use sort option
use pivot tables
11
Format Painter is used to
wrap cell
copy the border
apply same formatting
copy the background cell colour
12
What is Freeze Panes in MS-Excel?
To lock any rows
To lock any row or column
To lock any column
13
What is the use of LOOKUP function in Excel?
returns a value from a range or an array
applies data validation
custom sorts data
presents data graphically
14
AVERAGE, COUNT, COUNTIF, MAX, MIN, etc are which type of formula?
Statistical
Lookup & Reference
Logical
Maths & Trig
15
How will you fix/lock the cell/range reference?
Using ) symbol.
Using # symbol.
Using $ symbol.
Using % symbol.

Microsoft Excel Assessment 3 Flashcards | StudBud