MISY 5325 MS EXCEL MIDTERM EXAM
STUDY GUIDE EXAM | QUESTIONS & 100%
CORRECT ANSWERS (VERIFIED) | LATEST
UPDATE | GRADEA+
Which of the following is Not a number format available in the Number group on the
Home tab?
Correct Answer: Date Format
To begin a formula in a cell, first type the ...
MISY 5325 MS EXCEL M IDTERM EXAM STUDY GUIDE EXAM | QUESTIONS & 100% CORRECT ANSWERS (VERIFIED) | LATEST UPDATE | GRAD E A+ Which of the following is Not a number format available in the Number group on the Home tab? Correct Answer: Date Format To begin a formula in a cell, first type the # symbol. Correct Answer: False When you hide a column or row, the data is not deleted, it is just hidden. Correct Answer: True Text in a cell can by angle clockwise Correct Answer: True The ___ command is helpful for navigating to a cell that is not visible onscreen Correct Answer: Go to The ___ view displays print options and displays a worksheet in print preview Correct Answer: Office Backstage Comma, Date, Time, and Fraction are al l number formats available in Excel 2013. Correct Answer: True Click Format in the Cells group o the __ tab to change the color of a worksheet tab. Correct Answer: Home Formatting data makes it difficult to read and tends to obscure meaningful detail s. Correct Answer: False In Excel 2013, it is only possible to add a new worksheet when the workbook is created. Correct Answer: False Excel data can be copied and pasted into a Word or PowerPoint document. Correct Answer: True A Special number format allows characters such as hyphens. Correct Answer: True The Date number format only allows Long Date, for example, march 14, 2016. Correct Answer: False An argument is an operator such as an equal sign or a plus sign needed to complete a function. Correct Answer: False A range name cannot include special characters or __ Correct Answer: spaces Which of the following is a new feature in Excel 2013? Correct Answer: Quick Analysis Formula ___ displays a list of functions and defined name that match the letters that you start typing when creating a formula. Correct Answer: AutoComplete Which of the following is False about a function in Excel Correct Answer: Functions are organized into two categories in Excel. The IF function only evaluates a condition of the condition is true. Correct Answer: False Because the Sum function is a rarely used function it has no button on the Ribbon. Correct Answer: False An absolute cell reference: Correct Answer: indicates a cell's specific location and the reference does not change when you copy the formula. The lookup value: Correct Answer: is a reference to a cell containing a value to look up. The __ function finds the midpoint value of a list. Correct Answ er: Median The IF function: Correct Answer: evaluates a condition and returns one value if the condition is true, a different if false. A range name: Correct Answer: is a word or string of characters tat represent one or more cells. The IF functio n in Excel 2013 has __ arguments. Correct Answer: three A nested function:
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MASTER01. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for $14.49. You're not tied to anything after your purchase.