User Account

All Pages

Which of the following tabs is not found in format cells

Assignment Help Data Structure & Algorithms
Reference no: EM13944301

1. Which of the following is not a cell range?

a. B4:C6

b. A1:AA1

c. D3

d. 3D

2. If the value for Revenue is stored in C5 on Sheet1 and the value for Expenses is stored in C6 on Sheet2, the formula, revenue -expense would read:

a. =Sheet1@C5-Sheet2@C6

b. =Sheet1$C5-Sheet2$C6

c. =Sheet1!C5-Sheet2!C6

d. =Sheet1!C6-Sheet2!C5

3. If a formula adjusts itself automatically when copied, the cell reference is

a. Relative

b. Automatic

c. Absolute

d. Mixed

4. An absolute cell address:

a. relative to where it sits in the worksheet

b. always refers to an exact cell location in the worksheet.

c. is Excel's default method

d. cannot be used in a formula

5. The formula "=B6*(1+B3)" is in cell C6, how will you vocalize it?

a. "take the value appearing one cell to my right and then multiply it by 1 plus the value appearing three rows up and one column to the right."

b. "take the value appearing one cell to my left and then multiply it by 1 plus the value appearing three rows up and one column to the left."

c. "take the value appearing one cell to my left and then multiply it by 1 plus the value appearing three rows up and one column to the right."

d. "take the value appearing two cells to my right and then multiply it by 1 plus the value appearing three rows up and one column to the right."

6. In the alignment tab of the Format Cells dialog box, which of the following will you select to align cells vertically?

a. SELECT: an option from the Vertical drop-down list box

b. SELECT: Left (Indent) or Right (Indent) from the Horizontal drop-down list box

c. SELECT: a value in the Indent spin box to indent the cell contents

d. SELECT: Indent Spin Box

e. SELECT: Text Control

7. Which of the following tabs is not found in Format Cells dialog Box?

a. Number

b. Alignment

c. Border

d. Font

e. Orientation

8. In the formula =C10-(D10*(B3+B4)+2)/B7, which of the following would Excel evaluate first?

a. C10-D10

b. B3+B4

c. 2/B7

d. D10*(B3+B4)+2

e. can not be determined without knowing the cell contents

9. Which method will you use to test for two conditions using nesting?

a. =IF(condition,true,false)

b. =IF(condition,true,IF(condition,true,false))

c. =IF(condition,true,IF(condition,false))

d. =IF(condition,False,IF(condition,true))

e. =IF(condition,true,IF(true,false))

10. Which of the following is not one of the items included in the Goal Seek dialog box?

a. Set cell

b. By changing cell

c. End value

d. To value

e. all of these are in the Goal Seek dialog box

11. Which of the following would give you the correct date for 60 days from now?

a. =DATE()+60

b. =TODAY()+60

c. =NOW()+60

d. both B and C are correct

e. A, B, and C are all correct

12. Which of the following is the result of =LEN("Monitors, Used")?

a. 12

b. 13

c. 14

d. 15

e. 16

13. Cell B18 contains the label "Sales Commissions." What are the results of =SEARCH("C",B18)?

a. Sales Commissions

b. #NAME?

c. 7

d. 6

e. Not found

14. A cell displays Atlanta, Georgia. Most likely this cell has been modified by:

a. =LOWER

b. =PROPER

c. =UPPER

d. =LEN

e. =TRIM

Reference no: EM13944301

Questions Cloud

Research article on congenital heart failure : Write a 2.5 page on a scholarly research article on congenital heart failure
Explain how a form becomes a window within an application. : Discuss the difference between a modal and modeless form
Discuss the egocentric predicament : Compare and contrast rationalism and empiricism in their approach to the topic of knowledge. Discuss the Egocentric Predicament. How do you solve it?
Business scenario-consumers take a shine to apple : Assignment Context and Business Scenario Consumers Take a Shine to Apple Inc. Few companies have fans who sleep outside their doors in order to be the first to buy their latest products.
Which of the following tabs is not found in format cells : If the value for Revenue is stored in C5 on Sheet1 and the value for Expenses is stored in C6 on Sheet2, the formula, revenue -expense would read
Why are engineers not interested in experiments explain : Case Study: Science and Engineering. What does he mean when he says that engineering is top down? Why does this not work for science? Why are engineers not interested in experiments? Explain
Sample mean for the data on female : Here is your second chance to enter the sample mean for the data on female body temperatures. If you do not get it correct this time, you will be provided the correct answer and then continue on to the next question in the project. Your input must..
Define debt-financed income with respect to unrelated debt : Define each of the following with respect to unrelated debt-financed property. Debt-financed income. Debt-financed property. Acquisition indebtedness. Average acquisition indebtedness. Average adjusted basis.
Launching a new line of products for children : Identify and/or develop organisational objectives in regards to launching a new line of products for children and acknowledging Starbuck's younger customers

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Given algorithm looks for a value in a nondecreasing sequenc

Given algorithm looks for a value in a nondecreasing sequence and returns the index of the value if it is found or 0 if it is not found.

  Create two function for converting between units of distance

It's often necessary to convert between units. In this exercise, you will create two functions for converting between units of distance. The first function will be called ConvertMilesToKilometers(), which will accept one parameter for the number o..

  Eliminate every other integer beginning with the integer

the Collections class which has an algorithm called rotate(List list, int distance) which can be used to rotate a list left or right. use to eliminate every other Integer beginning with the Integer in the second position. Remember that if you rem..

  Data array a has data series from 1000000 to 1 with step

data array a has data series from 1000000 to 1 with step size 1 which is in perfect decreasing order.data array b has

  Create a flowchart that programs a robot to recognize

Create a flowchart that programs a robot to recognize how many playing cards you have and to put them in order from smallest to largest

  Design algorithm to produce list of customers

Design an algorithm to produce a list of customers from the Glad Rags Clothing Company's customer master file. Each record on the customer master file contains the customer's number.

  The ace is played when both the king

The Ace is played when both the King and Queen are showing on the table, or when neither the King and Queen are showing on the table.

  In this assignment you will write an essay on protein

in this assignment you will write an essay on protein requirements. begin by performing an internet search for high

  Research paper - cognitive modeling and human interaction

The paper can be a review that covers current solutions on Cognitive modeling and human interaction, or a research paper that proposes your own opinions/solutions.

  Calculation of a binary tree

Computations of a Binary Tree Write a function in C programming language that can find and return the height of a Binary Tree.

  Data array a has data series from 1000000 to 1 with step

data array a has data series from 1000000 to 1 with step size 1 which is in perfect decreasing order.data array b has

  Explain spacewise efficient implementation two-stack data

Structure of such two-stack data type would consist of two arrays and two top pointers. Describe why this may not be a spacewise efficient implementation.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd