Spreadsheet - Advanced Functions and Formulae

Flashcard
•
Computers
•
10th - 11th Grade
•
Hard
Wayground Content
FREE Resource
Student preview

20 questions
Show all answers
1.
FLASHCARD QUESTION
Front
A Lookup function is used to?
Back
compare a cell value to an ARRAY of cells and return a value that matches the location of the value in the array.
2.
FLASHCARD QUESTION
Front
This function returns the number of cells that meet a condition set forth in a formula.
Back
CountIf
3.
FLASHCARD QUESTION
Front
What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"? Options: Count, Countif, If, Vlookup
Back
If
4.
FLASHCARD QUESTION
Front
Which function would display "Yes" if D13 is greater than 0? Options: =IF(D13>0, "Yes", "No"), =IF(D13<0, "Yes", "No"), =IF(D13>0: "Yes", "No"), =IF(D13<0: "Yes", "No")
Back
=IF(D13>0, "Yes", "No")
5.
FLASHCARD QUESTION
Front
You are creating a spreadsheet that contains Community Service Hours goals. Column A lists the number of community service hours. Based on the value in column A, column B indicates if the community service hours goal of 500 hrs. was met. Choose the formula that will calculate if the goal was achieved.
Back
=IF(A1>=500, "Yes","No")
6.
FLASHCARD QUESTION
Front
The countif function uses two (2) arguments
Back
True
7.
FLASHCARD QUESTION
Front
The first argument in the CountIF function is range
Back
False
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Trigonometric Ratios

Flashcard
•
10th Grade
15 questions
Trigonometric Ratios

Flashcard
•
10th Grade
14 questions
Excel Functions and Formulas

Flashcard
•
9th - 11th Grade
18 questions
Excel Features

Flashcard
•
12th Grade
15 questions
Excel Functions Flashcard (M)

Flashcard
•
9th Grade
10 questions
Tin học 9

Flashcard
•
9th Grade
9 questions
Excel 2019 Flashcard

Flashcard
•
9th Grade
12 questions
JavaScript Programming Concepts

Flashcard
•
9th - 12th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Computers
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
40 questions
LSHS Student Handbook Review: Pages 7-9

Quiz
•
11th Grade
10 questions
Characteristics of Life

Quiz
•
9th - 10th Grade
10 questions
Essential Lab Safety Practices

Interactive video
•
6th - 10th Grade
20 questions
Scalars, Vectors & Graphs

Quiz
•
11th Grade
62 questions
Spanish Speaking Countries, Capitals, and Locations

Quiz
•
9th - 12th Grade